{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":166,"n_cols":12,"rows_kept":166,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[21,2,21,3],[37,2,37,3],[53,2,53,3],[69,2,69,3],[85,2,85,3],[100,2,100,3],[116,2,116,3],[132,2,132,3],[148,2,148,3],[164,2,164,3],[165,2,165,4]]}
["Школа",null,"МОУ \"Яльгелевский образовательный центр\"",null,null,"Утвердил:","должность","директор МОУ \"Яльгелевский образовательный центр\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Т.Н. Сергеева"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата"," "," ",2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша рисовая молочная с маслом сливочным",255,7.3,7.6,47.4,287.5,184]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,60.5,430]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"фрукты","яблоко свежее",100,0.4,0.4,9.9,44.6,338]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F10)","v":595},{"$f":"SUM(G6:G10)","v":10.9},{"$f":"SUM(H6:H10)","v":9.2},{"$f":"SUM(I6:I10)","v":92.9},{"$f":"SUM(J6:J10)","v":497.4}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","огурец свежий",100,0.8,0.1,2.5,14]
[null,null,null,"1 блюдо","суп картофельный с горохом",250,6.2,6,18.8,153.3,102]
[null,null,null,"1 блюдо","суп картофельный с рисом",250,2.6,3.4,16.9,108.4,101]
[null,null,null,"2 блюдо","котлеты рубленные из мяса птицы (куры)",100,8.9,11.7,10.3,188.1,294]
[null,null,null,"гарнир","капуста тушеная",180,4.2,5.1,17.8,136.9,346]
[null,null,null,"гарнир","макаронные изделия отварные",180,6.4,4.8,41.1,233.7,309]
[null,null,null,"напиток","напиток из плодов шиповника",200,0.7,0.3,28.8,132.5,388]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F12:F20)","v":1305},{"$f":"SUM(G12:G20)","v":33},{"$f":"SUM(H12:H20)","v":32.2},{"$f":"SUM(I12:I20)","v":157.1},{"$f":"SUM(J12:J20)","v":1070.3}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F11+F21","v":1900},43.9,41.4,250,1567.7]
[1,2,"Завтрак","гор.блюдо","каша манная молочная с маслом сливочным",255,8.5,7.3,43.2,272.2,184]
[null,null,null,"гор.напиток","чай с лимоном",207,0.3,0,15.2,62.8,377]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"сладкое","пряники",60,3.5,2.8,45,219.6," "]
[]
[null,null,null,"итого",null,{"$f":"SUM(F23:F27)","v":562},{"$f":"SUM(G23:G27)","v":15.3},{"$f":"SUM(H23:H27)","v":11.3},{"$f":"SUM(I23:I27)","v":124},{"$f":"SUM(J23:J27)","v":659.4}]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Обед","закуска","огурец соленый",100,0.8,0.1,1.7,13," "]
[null,null,null,"1 блюдо","борщ с капустой и картофелем со сметаной",255,2.7,6.3,12.4,118.6,82]
[null,null,null,"1 блюдо","щи из свежей капусты со сметаной",255,2.6,6.4,6.9,97.3,87]
[null,null,null,"2 блюдо","жаркое по-домашнему из курицы",280,29.9,35.2,27,544.8,258]
[null,null,null,"2 блюдо","рыба, запеченная с картофелем по-русски",280,17.2,13.2,20.9,269.1,235]
[null,null,null,"напиток","компот из свежих плодов",200,0.2,0.2,27.1,111.1,394]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F29:F36)","v":1415},{"$f":"SUM(G29:G36)","v":56.6},{"$f":"SUM(H29:H36)","v":62.2},{"$f":"SUM(I29:I36)","v":116.9},{"$f":"SUM(J29:J36)","v":1256.9}]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Итого за день:",null,null,{"$f":"F28+F37","v":1977},71.9,73.5,240.9,1916.3]
[1,3,"Завтрак","гор.блюдо","омлет натуральный",140,12.6,21,2.4,249.2,214]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,60.5,430]
[null,null,null,"хлеб","батон обогащенный",60,4.5,1.7,30.8,157.2]
[null,null,null,"фрукты","апельсин",150,1.4,0.3,12.2,64.5,338]
[null,null,null,"итого",null,{"$f":"SUM(F39:F42)","v":550},{"$f":"SUM(G39:G42)","v":18.7},{"$f":"SUM(H39:H42)","v":23},{"$f":"SUM(I39:I42)","v":60.4},{"$f":"SUM(J39:J42)","v":531.4}]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Обед","закуска","салат из квашеной капусты",100,1.6,5.1,8.2,87.7,40]
[null,null,null,"1 блюдо","суп из овощей со сметаной",255,2.4,6.5,11.1,113.6,99]
[null,null,null,"1 блюдо","уха",250,7.2,5.6,16.9,146.4]
[null,null,null,"2 блюдо","птица, тушенная в соусе",100,14,16.8,3,225,290]
[null,null,null,"гарнир","макаронные изделия отварные",180,6.5,4.8,41.4,235,309]
[null,null,null,"гарнир","каша гречневая рассыпчатая",180,10.6,6.8,47.8,294.4,181]
[null,null,null,"напиток","напиток из плодов шиповника",200,0.7,0.3,28.8,132.5,388]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F44:F52)","v":1310},{"$f":"SUM(G44:G52)","v":46.2},{"$f":"SUM(H44:H52)","v":46.7},{"$f":"SUM(I44:I52)","v":178.1},{"$f":"SUM(J44:J52)","v":1338}]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Итого за день:",null,null,{"$f":"F43+F53","v":1860},64.9,69.7,238.5,1869.4]
[1,4,"Завтрак","гор.блюдо","каша овсяная со сливочным маслом",255,10.1,10.3,40.9,297.6,184]
[null,null,null,"сладкое","вафли",60,1.6,2,39.9,211.9]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,60.5,430]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"итого",null,{"$f":"SUM(F55:F58)","v":555},{"$f":"SUM(G55:G58)","v":14.9},{"$f":"SUM(H55:H58)","v":13.5},{"$f":"SUM(I55:I58)","v":116.4},{"$f":"SUM(J55:J58)","v":674.8}]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Обед","закуска","салат из белокачанной капусты и моркови",100,1.5,5.1,9.3,89.9,35]
[null,null,null,"1 блюдо","борщ с капустой и картофелем со сметаной",255,2.7,6.3,12.4,118.6,82]
[null,null,null,"1 блюдо","рассольник ленинградский со сметаной",255,2.9,6.7,16.6,139.3,96]
[null,null,null,"2 блюдо","биточки мясные с соусом томатным",100,7.9,23.9,11.2,291.4,283]
[null,null,null,"гарнир","картофельное пюре",180,3.9,5.3,26.3,168.8,128]
[null,null,null,"гарнир","рис припущенный",180,4.3,4.6,45.2,239.8,305]
[null,null,null,"напиток","напиток из плодов шиповника",200,0.7,0.3,28.8,132.5,388]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F60:F68)","v":1315},{"$f":"SUM(G60:G68)","v":27.1},{"$f":"SUM(H60:H68)","v":53},{"$f":"SUM(I60:I68)","v":170.7},{"$f":"SUM(J60:J68)","v":1283.7}]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Итого за день:",null,null,{"$f":"F59+F69","v":1870},42,66.5,287.1,1958.5]
[1,5,"Завтрак","гор.блюдо","каша молочная \"дружба\"",255,7.4,7.9,42.1,269.4,175]
[null,null,null,"гор.напиток","какао с молоком",200,3.8,3,24.5,141.1,382]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"фрукты","груша",100,0.4,0.3,10.3,47]
[null,null,null,"итого",null,{"$f":"SUM(F71:F74)","v":595},{"$f":"SUM(G71:G74)","v":14.6},{"$f":"SUM(H71:H74)","v":12.4},{"$f":"SUM(I71:I74)","v":97.5},{"$f":"SUM(J71:J74)","v":562.3}]
[{"$f":"A71","v":1},{"$f":"B71","v":5},"Обед","закуска","салат из свеклы с маслом растительным",100,1.6,5,12.6,101.3,"к/к"]
[null,null,null,"1 блюдо","суп куриный с вермишелью, картофелем",255,3.7,3.7,20.2,129.5,100]
[null,null,null,"1 блюдо","щи из свежей капусты со сметаной",255,2.6,6.4,6.9,97.3,87]
[null,null,null,"2 блюдо","печень по-строгановски",100,14.5,12.7,3.9,192.5,255]
[null,null,null,"гарнир","каша гречневая рассыпчатая",180,10.6,6.8,47.8,294.4,181]
[null,null,null,"гарнир","макаронные изделия отварные",180,6.5,4.8,41.4,235,309]
[null,null,null,"напиток","компот из смеси сухофруктов",200,0.6,0.1,31.7,131,402]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F76:F84)","v":1315},{"$f":"SUM(G76:G84)","v":43.3},{"$f":"SUM(H76:H84)","v":40.3},{"$f":"SUM(I76:I84)","v":185.4},{"$f":"SUM(J76:J84)","v":1284.4}]
[{"$f":"A71","v":1},{"$f":"B71","v":5},"Итого за день:",null,null,{"$f":"F75+F85","v":1910},57.9,52.7,282.9,1846.7]
[2,1,"Завтрак","гор.блюдо","суп молочный с макаронными изделиями",250,5.7,4.9,21.7,155,112]
[null,null,null,"гор.напиток","чай с лимоном",207,0.2,0,15,61.6,377]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"сладкое","печенье",60,4.5,5.9,44.6,250.2]
[null,null,null,"итого",null,{"$f":"SUM(F87:F90)","v":557},{"$f":"SUM(G87:G90)","v":13.4},{"$f":"SUM(H87:H90)","v":12},{"$f":"SUM(I87:I90)","v":101.9},{"$f":"SUM(J87:J90)","v":571.6}]
[{"$f":"A87","v":2},{"$f":"B87","v":1},"Обед","закуска","огурец свежий",100,0.8,0.1,2.5,14," "]
[null,null,null,"1 блюдо","борщ с капустой и картофелем, со сметаной",255,2.7,6.3,12.4,118.6,82]
[null,null,null,"1 блюдо","суп картофельный с горохом",250,6.2,6,18.8,153.3,102]
[null,null,null,"2 блюдо","голубцы ленивые",280,20.4,50.8,21.5,624.9,306]
[null,null,null,"гарнир","плов из птицы",280,28.8,37.3,49.5,648,291]
[null,null,null,"напиток","компот из свежих яблок",200,0.2,0.2,27.1,111.1,"342.1"]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F92:F99)","v":1410},{"$f":"SUM(G92:G99)","v":62.3},{"$f":"SUM(H92:H99)","v":101.5},{"$f":"SUM(I92:I99)","v":152.7},{"$f":"SUM(J92:J99)","v":1773.3}]
[{"$f":"A87","v":2},{"$f":"B87","v":1},"Итого за день:",null,null,{"$f":"F91+F100","v":1967},75.7,113.5,254.6,2344.9]
[2,2,"Завтрак","гор.блюдо","каша рисовая молочная с маслом сливочным",255,7.3,7.6,47.4,287.5,184]
[null,null,null,"гор.напиток","чай с сахаром",200,0.1,0,14.8,59.3,376]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"фрукты","яблоко свежее",100,0.4,0.4,9.9,44.6,338]
[null,null,null,"итого",null,{"$f":"SUM(F102:F105)","v":595},{"$f":"SUM(G102:G105)","v":10.8},{"$f":"SUM(H102:H105)","v":9.2},{"$f":"SUM(I102:I105)","v":92.7},{"$f":"SUM(J102:J105)","v":496.2}]
[{"$f":"A102","v":2},{"$f":"B102","v":2},"Обед","закуска","огурец соленый",100,0.8,0.1,1.7,13]
[null,null,null,"1 блюдо","суп из овощей со сметаной",255,2.4,6.5,11.1,113.6,99]
[null,null,null,"1 блюдо","уха",250,7.2,5.6,16.9,146.4]
[null,null,null,"2 блюдо","гуляш из свинины",100,11.9,32.3,5.5,361.6,259]
[null,null,null,"гарнир","картофельное пюре",180,3.9,5.7,26.3,171.7,128]
[null,null,null,"гарнир","макаронные изделия отварные",180,6.5,4.8,41.4,234.7,309]
[null,null,null,"напиток","компот из смеси сухофруктов",200,0,0,19.4,77.4,349]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F107:F115)","v":1310},{"$f":"SUM(G107:G115)","v":35.9},{"$f":"SUM(H107:H115)","v":55.8},{"$f":"SUM(I107:I115)","v":143.2},{"$f":"SUM(J107:J115)","v":1221.8}]
[{"$f":"A102","v":2},{"$f":"B102","v":2},"Итого за день:",null,null,{"$f":"F106+F116","v":1905},46.7,65,235.9,1718]
[2,3,"Завтрак","гор.блюдо","каша пшенная молочная с маслом сливочным",255,10.5,8.5,53.4,261,189]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,60.5,430]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"сладкое","пряники",60,3.5,2.8,45,219.6]
[null,null,null,"итого",null,{"$f":"SUM(F118:F121)","v":555},{"$f":"SUM(G118:G121)","v":17.2},{"$f":"SUM(H118:H121)","v":12.5},{"$f":"SUM(I118:I121)","v":134},{"$f":"SUM(J118:J121)","v":645.9}]
[{"$f":"A118","v":2},{"$f":"B118","v":3},"Обед","закуска","салат из белокачанной капусты и моркови",100,1.5,5.1,9.3,9.3,35]
[null,null,null,"1 блюдо","борщ с капустой и картофелем со сметаной",255,2.7,6.3,12.4,118.6,82]
[null,null,null,"1 блюдо","щи из свежей капусты со сметаной",255,2.5,6.4,6.7,95.7,87]
[null,null,null,"2 блюдо","птица, тушенная в соусе",100,14,16.8,3,225,290]
[null,null,null,"гарнир","капуста тушеная",180,4.2,5.1,17.8,136.9,346]
[null,null,null,"гарнир","рис припущенный",180,4.3,4.6,45.2,239.8,305]
[null,null,null,"напиток","компот из свежих плодов",200,0.2,0.2,27.9,115,394]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F123:F131)","v":1315},{"$f":"SUM(G123:G131)","v":32.6},{"$f":"SUM(H123:H131)","v":45.3},{"$f":"SUM(I123:I131)","v":143.2},{"$f":"SUM(J123:J131)","v":1043.7}]
[{"$f":"A118","v":2},{"$f":"B118","v":3},"Итого за день:",null,null,{"$f":"F122+F132","v":1870},49.8,57.8,277.2,1689.6]
[2,4,"Завтрак","гор.блюдо","каша овсяная со сливочным маслом",255,10.1,10.3,40.9,297.6,184]
[null,null,null,"гор.напиток","чай с сахаром и лимоном",207,0.3,0.1,15.2,62,431]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"фрукты","апельсин",100,0.9,0.2,8.1,43," "]
[null,null,null,"итого",null,{"$f":"SUM(F134:F137)","v":602},{"$f":"SUM(G134:G137)","v":14.3},{"$f":"SUM(H134:H137)","v":11.8},{"$f":"SUM(I134:I137)","v":84.8},{"$f":"SUM(J134:J137)","v":507.4}]
[{"$f":"A134","v":2},{"$f":"B134","v":4},"Обед","закуска","салат из квашеной капусты",100,1.6,5.1,8.2,87.7,40]
[null,null,null,"1 блюдо","рассольник ленинградский со сметаной",255,2.9,6.7,16.6,139.9,96]
[null,null,null,"1 блюдо","суп куриный с вермишелью, картофелем",255,3.3,3.4,20.2,124.9,100]
[null,null,null,"2 блюдо","котлеты рубленные из мяса птицы(куры)",100,8.9,11.7,10.3,188.1,294]
[null,null,null,"гарнир","макаронные изделия отварные",180,6.5,4.8,41.4,235,309]
[null,null,null,"гарнир","картофельное пюре",180,3.9,5.7,26.3,171.7,128]
[null,null,null,"напиток","компот из свежих плодов",200,0.2,0.2,27.9,115,394]
[null,null,null,"хлеб бел.","батон обогащенный",25,1.9,0.7,12.9,65.5]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",25,1.7,0.2,10.6,51]
[null,null,null,"итого",null,{"$f":"SUM(F139:F147)","v":1320},{"$f":"SUM(G139:G147)","v":30.9},{"$f":"SUM(H139:H147)","v":38.5},{"$f":"SUM(I139:I147)","v":174.4},{"$f":"SUM(J139:J147)","v":1178.8}]
[{"$f":"A134","v":2},{"$f":"B134","v":4},"Итого за день:",null,null,{"$f":"F138+F148","v":1922},45.2,50.3,259.2,1686.2]
[2,5,"Завтрак","гор.блюдо","макаронные изделия отварные с сыром",250,12.5,10.8,50.4,349.5,331]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,60.5,430]
[null,null,null,"хлеб","батон обогащенный",40,3,1.2,20.6,104.8]
[null,null,null,"сладкое","вафли",50,1.3,1.7,33.1,175.9]
[null,null,null,"итого",null,{"$f":"SUM(F150:F153)","v":540},{"$f":"SUM(G150:G153)","v":17},{"$f":"SUM(H150:H153)","v":13.7},{"$f":"SUM(I150:I153)","v":119.1},{"$f":"SUM(J150:J153)","v":690.7}]
[{"$f":"A150","v":2},{"$f":"B150","v":5},"Обед","закуска","огурец соленый",100,0.8,0.1,1.7,13," "]
[null,null,null,"1 блюдо","суп из овощей со сметаной",255,2.4,6.5,11.1,113.6,99]
[null,null,null,"1 блюдо","суп картофельный с горохом",250,6.2,6,18.8,153.3,102]
[null,null,null,"2 блюдо","биточки мясные с соусом томатным",100,7.9,23.9,11.2,291,283]
[null,null,null,"гарнир","рис припущенный",180,4.3,4.6,45.2,239.8,305]
[null,null,null,"гарнир","каша гречневая рассыпчатая",180,10.6,6.8,47.8,294.4,181]
[null,null,null,"напиток","компот из изюма",200,0.5,0.1,36.1,147.4,401]
[null,null,null,"хлеб бел.","батон обогащенный",20,1.5,0.6,10.3,52.4]
[null,null,null,"хлеб черн.","хлеб ржано-пшеничный обог. микронутриентами",30,2,0.3,12.7,61.2]
[null,null,null,"итого",null,{"$f":"SUM(F155:F163)","v":1315},{"$f":"SUM(G155:G163)","v":36.2},{"$f":"SUM(H155:H163)","v":48.9},{"$f":"SUM(I155:I163)","v":194.9},{"$f":"SUM(J155:J163)","v":1366.1}]
[{"$f":"A150","v":2},{"$f":"B150","v":5},"Итого за день:",null,null,{"$f":"F154+F164","v":1855},53.2,62.6,314,2056.8]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F22+F38+F54+F70+F86+F101+F117+F133+F149+F165)/(IF(F22=0,0,1)+IF(F38=0,0,1)+IF(F54=0,0,1)+IF(F70=0,0,1)+IF(F86=0,0,1)+IF(F101=0,0,1)+IF(F117=0,0,1)+IF(F133=0,0,1)+IF(F149=0,0,1)+IF(F165=0,0,1))","v":1903.6},55.12,65.3,264.03,1865.41]